package com.hubu.jwxt.beans;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Course {
    /*
    CREATE TABLE `course`  (
  `c_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '课程ID',
  `c_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '课程名称',
  `c_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '课程描述',
  `c_score` int(20) NOT NULL COMMENT '课程学分',
  `c_time` int(5) NOT NULL COMMENT '课时',
  `c_maxnum` int(5) NOT NULL COMMENT '课程最大容量',
  `c_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '已选学生数量',
  `t_id` int(5) NOT NULL COMMENT '教这门课的老师ID',
  `semester_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学期',
  PRIMARY KEY (`c_id`) USING BTREE,
  INDEX `t_id`(`t_id`) USING BTREE,
  INDEX `semester`(`semester_time`) USING BTREE,
  CONSTRAINT `semester` FOREIGN KEY (`semester_time`) REFERENCES `semester` (`semester_name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `teacher` (`t_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;
     */

    private int c_id;
    private String c_name;
    private String c_desc;
    private int c_score;
    private int c_time;
    private int c_maxnum;
    private String c_num;
    private int t_id;
    private String semester_time;
}
